[dbo].[AsyncStatusMonitor]

SQLServer > iMIS1521GA > Tables > dbo.AsyncStatusMonitor

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Row Count	0
Created	10:31:13 AM Tuesday, March 02, 2010
Last Modified	11:40:00 AM Monday, February 20, 2012

Columns

Name	Data Type	Max Length (Bytes)
AsyncStatusMonitorKey	uniqueidentifier	16
ComponentKey	uniqueidentifier	16
BusinessItemKey	uniqueidentifier	16
WorkflowQueueItemKey	uniqueidentifier	16
CreatedOn	datetime	8

Indexes

	Name	Columns	Unique
	PK_AsyncStatusMonitor	AsyncStatusMonitorKey

SQL Script

CREATE TABLE [dbo].[AsyncStatusMonitor]
(
[AsyncStatusMonitorKey] [uniqueidentifier] NOT NULL,
[ComponentKey] [uniqueidentifier] NOT NULL,
[BusinessItemKey] [uniqueidentifier] NOT NULL,
[WorkflowQueueItemKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AsyncStatusMonitor] ADD CONSTRAINT [PK_AsyncStatusMonitor] PRIMARY KEY CLUSTERED ([AsyncStatusMonitorKey]) ON [PRIMARY]
GO

Uses